Arbutus DQM is an add on Hub server-based tool that is only available in AnalyzerPlus and that leverages the results of the extended Profile command in AnalyzerPlus. Only extended profiles created for tables in Hub server shared folders can utilize Arbutus DQM.

Arbutus DQM allows users to identify anomalies in the extended results of the Profile command and establish regularly recurring DQM (Data Quality Management) processes containing necessary tests that can be outputted via email to a user, to a table, and/or for use with the Results command to populate Results Manager for further assignment and exception reviews.

Enhanced the Results Command

Enhanced the Results command to support the user being able to fill out an initial existing form as part of the results sent to the Results Manager.

Added Local Compression and Encryption for Creating Tables (Available in Analyzer Plus)

Added an option to compress and encrypt local data created by AnalyzerPlus commands that output results to a table. The options to compress and encrypt data are found in Tools/Options/Table. Status of compression/encryption now displayed in the project items Overview properties.

Added Command Dialog for Directory Command

Added a command dialog for the Directory command in the Tools menu.

Added New Smart Apps in V9

Added new sets of Smart Apps for:

•

Human Resources

•

Payroll

•

Machine Learning

•

Open AI

Added New Connectors in V9

Added new connectors for:

•

SAP for ERP

•

Dynamics 365 Business Central

•

Oracle SCM

•

Oracle Sales

•

Databricks

•

Azure Active Directory

Added In-Line Comments for Procedures

Analyzer now supports in-line comments at the end of a command in a procedure rather than using block comments with the Comment command. This is useful where individual lines in a procedure require command specific comments.

•

To enter an in-line comment in procedure, at the end of the command (typically separated by one or more tabs for spacing), type // followed by the line comment.

•

To exclude line comments from appearing in the Command Log, at the end of the command (typically separated by one or more tabs for spacing), type /// followed by the line comment.

Added Support for Single Sign On (SSO) for Server Profiles

Updated server profiles for connecting to Arbutus Servers to enable use of Integrated Windows Authentication (Single Sign-On) - this option is unchecked by default. When checked, enables single sign-on (SSO), and alleviates the need to enter a User ID and Password for the server profile by greying out the User ID and Password.

Added DATETIME() Function

The DATETIME() function converts an actual datetime field or expression into a character expression. The user can also specify an optional date format to ensure the character expression created reflects the desired date format.

Added WEEKNUM() Function

WEEKNUM() returns the week number for a specified datetime in a calender year. An optional starting day of the week can be specified.

Added Ability To Export Server Profiles

There are times you may want to share existing server profiles that you use to connect to Arbutus Servers with other users.

Analyzer has added the ability to export your existing server profiles to a Profiles.TXT file.

Exporting Server Profiles

To export all information for your existing server profiles (including the user id and encrypted password for each server profile), simply:

Click the Server menu

Choose Export Profiles

All existing server profile information stored in your local user registry, and any server profile information contained in an existing Profiles.TXT that you are using in your Analyzer project root, will be combined into an exported file called "_Profiles.TXT". This file is placed by default in your current Analyzer project root.

Once this file is created, you can edit the saved "_Profiles.TXT" (prior to renaming and sharing it) to remove any stored user ids and encrypted passwords. This will force other users utilizing this file to be prompted to enter and optionally save their own user ids and passwords in their local user registry.

Exporting server profiles does not remove the stored server profiles. They are simply copied to the new "_Profiles.TXT".

To utilize the "_Profiles.TXT" file, simply rename the file to "Profiles.TXT" and provide it to the necessary Analyzer users. They must place this file into their local Analyzer project root.

Enhanced LEFT() and RIGHT() Functions

Enhanced the LEFT() and RIGHT() functions to support a numeric value for the length that is not a constant.

Enhanced the Edit Box control in the Dialog Command

Enhanced the Edit Box control in the Dialog command. When choosing the variable type “filename” or "folder", entering a valid path in the Default Text box enables users to specify a default valid starting path for browsing.

Improved Entry of Multi-Line SQL Select Statements

For the SQL command, the Database Explorer, and in the ODBC Wizard you can now paste or enter multi-line SQL Select statements for better readability.

Added Numeric Formatting Support For Foreign Currency Symbols

Added numeric formatting support for valid Print field type data containing non-North American currency characters (specifically Euro and Pound symbols).

Enhanced EOMONTH() Function

Enhanced the EOMONTH() function to enable an optional MONTHS parameter that allows you to specify a positive or negative whole number of months. When this optional parameter is used, the function will then return the end of month that precedes or follows the end of month for the actual supplied DateTime.

Added Default Export Preference

The Default Export allows users to specify their preferred default export option for the Export command.

Added Native API Support for Importing Tables from SQL Server and Oracle

When selecting a data source (in the Data Definition Wizard or in the SQL command), if a native DSN is selected for SQL Server or Oracle, Analyzer automatically selects the Use Native API checkbox to cause Analyzer to utilize the native API rather than ODBC to import the data. This will improve importing performance.

Additionally, the Data Definition Wizard will generate a new Import command using the new syntax IMPORT ODBC API. The SQL command will generate a new SQL command using the new syntax SQL API.

Enhanced Append Command Output Options

Enhanced the Append command's Output options to enable choosing an alternate location for the data created by the Append command. This ensures consistency with output options for other commands.

Augmented Monthly Scheduling Options

Augmented Scheduling options for monthly scheduled jobs on the Arbutus Hub Server to allow users to specify a monthly frequency/cycle. This is particularly useful as it enables users to schedule quarterly jobs based on a specified start month and date using a 3 month frequency/cycle.

Added Field Level Rules

Added the ability to specify field level rules in the Edit Table Layout dialog or when using the DEFINE FIELD command.

Field level rules can be used to specify:

•

Minimum values

•

Maximum values

•

Format (character fields only)

•

All blank invalid (numeric fields)

•

All blank valid (character and date fields)

Established Field level rules can be applied to the Verify command so that field values are additionally validated against any specified field level rules and any violations of the rules are reported.

•

In the Verify dialog choose the "Test Field Rules" check box

•

In the Verify command specify the "Rules" parameter

Added New Connectors in V9.1

Added new connectors for:

•

SAP Netweaver

Added the Ability to Move Multiple Columns in the View

Added the ability to mass select multiple columns in the View using Shift-click or CTRL-click and then move the selected columns within the View.

Added Speed Search to the Append Command

Added Speed Search to the Append Command to make searching for tables in long table lists easier.

Enhanced Searching the Command Log

Enhanced the right-click options you can use to search the Command Log:

•

Choose a session to go to - presents a list of sessions, double click on the session to go to.

•

Go to Previous Session

•

Go to Next Session

•

Go to Previous Command

•

Go to Next Command

Added a Shared Folder Warning

In the Overview, a red X icon will be displayed on the shared folder if the shared folder cannot be located.

Enhanced AI Sentiment Analysis Smart App in V9.1

Enhanced AI Sentiment Analysis Smart App to support non-English languages.

Streamlined Entering SAP Info for SmartLink

Streamlined entry of SAP Info for SmartLink:

•

Removed the SAP Options from the Tools menu

•

Moved entry of the SAP userid, password, client and language to the Admin Tool>Manage Data Sources

•

Moved the "Add SAP Table to field names" option to the SmartLink tables dialog

Moved the Server Profile Export from the Server Menu

Moved the ability to export server profiles to the Server Profile window.

To export your server profiles, click the Export button in any server profile.

Clicking Export will export all existing server profiles stored in your local user registry, and any server profiles contained in an existing Profiles.TXT that you are using in your Analyzer install or project folder, into a combined exported file called "_Profiles.TXT". This file is placed by default in your current Analyzer project root.

Added a Shared Folder Export to the Manage Shared Folders Dialog

Added the ability to export shared folders.

To export your shared folders, click the Export button at the top right of the Manage Shared Folders dialog in the Share Menu.

Clicking Export will export all existing shared folders stored in your local user registry into an exported file called "_Shared.TXT". This file is placed by default in your current Analyzer project root.